exec sp_drop 'u.setIdentity, u'
go

create schema u authorization dbo
go



create procedure u.setIdentity 
  @ID int
as
  if @ID is null return
  create table #t (ID int identity(1,1))
  set identity_insert #t on
  insert #t (ID) values(@ID)
  set identity_insert #t off
go




